package com.yxuan.springboot.mapper;


import com.yxuan.springboot.model.SchoolScore;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * 
 * @author zchao
 *    SchoolScoreMapper层
 * @date 2023-06-05 19:58:20
 */
@Mapper
public interface SchoolScoreMapper extends BaseMapper<SchoolScore> {



    List<Integer> findAllAvailableSchoolsId(@Param("lowest_order") String lowest_order,@Param("province") String province) throws Exception;


    Integer findAllAvailableNumber(@Param("lowest_order") String lowest_order,@Param("province") String province) throws Exception;

    List<SchoolScore> findAlldatedSubject(@Param("targetYear") String targetYear,@Param("province") String province,@Param("schoolId") Integer schoolId) throws Exception;

    List<SchoolScore> findScoreInfoBySchoolId(@Param("idList") List idList, @Param("province") String province, @Param("scoreYear") String scoreYear, @Param("lotType") String lotType);
}
